Database management systems

The Accruent Meridian Enterprise suite supports the following database management systems.

Besides the Microsoft Jet database engine (installed separately) or SQLite (embedded), Meridian Enterprise supports the following database management systems for local workspace data management.

Supported versions of Microsoft SQL Server Compact Edition
Version1 2017 2018 2019
SQL Server Compact Edition 4.0
SQL Server Compact Edition 3.5

Accruent Meridian Enterprise supports the following database management systems for the storage of Meridian Enterprise vault, Meridian Enterprise Server configuration, Meridian Explorer repository, and Accruent Publisher log databases.

Supported versions of Microsoft SQL Server (32-bit and 64-bit versions)
Version1,3 Meridian Enterprise Meridian Enterprise Server Meridian Explorer2 Accruent
Publisher
SQL Server 2017
SQL Server 2016
SQL Server 2014
SQL Server 2012
Supported versions of Oracle
Version4 Meridian Enterprise Meridian Enterprise Server Meridian Explorer5 Accruent
Publisher
Oracle 18c Release 2 (18.0.0.0)
Oracle 12c Release 2 (12.2.0.1)
Oracle 12c Release 1 (12.1.0.2)
Oracle 11g Release 2 (11.2.0.1)
Oracle 11g Release 1 (11.1.0.7)
Note:

  1. The Express editions of SQL Server are supported for evaluation, development, and demonstration purposes only. They are also supported for the Meridian Enterprise Server configuration database only when Meridian Explorer is not configured. We do not recommend it for any environments. Accruent does not routinely test the Express editions for compatibility, performance, stability, or scalability. When Meridian Explorer is configured, the Standard or Enterprise edition of SQL Server must be used. SQL Server failover clusters are supported.

  2. 64-bit only

    Database collation determines if queries and T-SQL script are case-sensitive or case-insensitive.Meridian Explorer requires case-insensitive database collation, which can be set either on the server level or on the database level. To set the collation at the server level, see Set or Change the Server Collation. To set the collation at the database level, see Set or Change the Database Collation.

    The Full Text Search component is not installed by default, but is required on servers where repositories will be created. The Full Text Search component is only included in the following editions of SQL Server: Express with Advanced Services, Standard, and Enterprise editions.

    Microsoft SQL Server provides a FILESTREAM feature for higher performance that we recommend and is enabled by default during repository creation. Before using this feature, we strongly recommend that you fully understand the advantages, limitations, and implications of the feature by studying the Microsoft SQL Server documentation. For an overview, see Binary Large Object (Blob) Data (SQL Server) on Microsoft TechNet.

  3. Beginning with Meridian Enterprise 2018 R2 Update 1, the Microsoft OLE DB Driver for SQL Server must be installed on the Meridian server to create vaults stored in any version of SQL Server. This driver adds support for the latest TLS 1.2 standards and is backward compatible with the SQL Server Native Client but is not included with the client. The driver is required whether TLS 1.2 is used or not.

    For more information about and to download the Microsoft OLE DB Driver for SQL Server (MSOLEDBSQL), which replaces the legacy OLE DB Provider for SQL Server (SQLOLEDB), see:

  4. Oracle Standard Edition and Enterprise Edition are supported unless otherwise noted. We assume that non-Windows versions of Oracle are compatible with the Windows versions (as pertains to Meridian Enterprise compatibility). Accruent supports non-Windows configurations, but does not test them. For more information on testing and supporting non-Windows versions, contact Accruent Technical Support.

    The Oracle Text component is not installed by default, but is required on servers where repositories will be created.

    Oracle Real Application Clusters (RAC) are supported. Contact Accruent Technical Support for more information.

  5. Oracle Standard Edition is not supported. The Enterprise Edition is required.